 二级栏目权限表 SQL，注：9为t_right_types表中的id,为顶部导航栏目
权限对应路由 SQL：注：id需手动填写
-- 二级栏目权限表 SQL，注：9为t_right_types表中的id,为顶部导航栏目
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}查询', '', '');
SELECT @selectId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}新增页面', '', '');
SELECT @addPageId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}新增保存', '', '');
SELECT @addId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}修改页面', '', '');
SELECT @updatePageId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}修改保存', '', '');
SELECT @updateId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}单项删除', '', '');
SELECT @deleteId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}批量删除', '', '');
SELECT @deleteBatchId := LAST_INSERT_ID();
insert into t_rights (type_id, name,code,description)values(9, '${model.comment}详情', '', '');
SELECT @showId := LAST_INSERT_ID();

-- 权限对应路由 SQL：注：id需手动填写
insert into t_right_actions (id, right_id, action, description)
values('8991', @selectId,'supervisor.${model.modulePackage}.${model.model}Action.list','${model.comment}查询');
insert into t_right_actions (id, right_id, action, description)
values('8992', @addPageId,'supervisor.${model.modulePackage}.${model.model}Action.addPage','${model.comment}新增页面');
insert into t_right_actions (id, right_id, action, description)
values('8993', @addId,'supervisor.${model.modulePackage}.${model.model}Action.add','${model.comment}新增保存');
insert into t_right_actions (id, right_id, action, description)
values('8994', @updatePageId,'supervisor.${model.modulePackage}.${model.model}Action.editPage','${model.comment}修改页面');
insert into t_right_actions (id, right_id, action, description)
values('8995', @updateId,'supervisor.${model.modulePackage}.${model.model}Action.edit','${model.comment}修改保存');
insert into t_right_actions (id, right_id, action, description)
values('8996', @deleteId,'supervisor.${model.modulePackage}.${model.model}Action.delete','${model.comment}单项删除');
insert into t_right_actions (id, right_id, action, description)
values('8997', @deleteBatchId,'supervisor.${model.modulePackage}.${model.model}Action.deleteBatch','${model.comment}批量删除');
insert into t_right_actions (id, right_id, action, description)
values('8998', @showId,'supervisor.${model.modulePackage}.${model.model}Action.show','${model.comment}详情');

-- 管理员的权限表 SQL
insert into t_rights_of_supervisor (right_id,supervisor_id)
values(@selectId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@addPageId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@addId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@updatePageId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@updateId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@deleteId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@deleteBatchId,1);
insert into t_rights_of_supervisor (right_id, supervisor_id)
values(@showId,1);


/*
#路由${model.comment}
*   /${model.packageName}/${model.modulePackage}/${model.model}Action/list             supervisor.${model.modulePackage}.${model.model}Action.list
GET   /${model.packageName}/${model.modulePackage}/${model.model}Action/addPage           supervisor.${model.modulePackage}.${model.model}Action.addPage
POST   /${model.packageName}/${model.modulePackage}/${model.model}Action/add            supervisor.${model.modulePackage}.${model.model}Action.add
GET   /${model.packageName}/${model.modulePackage}/${model.model}Action/editPage              supervisor.${model.modulePackage}.${model.model}Action.editPage
POST   /${model.packageName}/${model.modulePackage}/${model.model}Action/edit             supervisor.${model.modulePackage}.${model.model}Action.edit
POST   /${model.packageName}/${model.modulePackage}/${model.model}Action/show              supervisor.${model.modulePackage}.${model.model}Action.show
POST   /${model.packageName}/${model.modulePackage}/${model.model}Action/delete                supervisor.${model.modulePackage}.${model.model}Action.delete
POST   /${model.packageName}/${model.modulePackage}/${model.model}Action/deleteBatch              supervisor.${model.modulePackage}.${model.model}Action.deleteBatch

//${model.comment}菜单 带权限的标签
#{operation key:'${model.packageName}.${model.modulePackage}.${model.model}Action.list',class:'xn_c_li_head_twoli',id:"mg_120",show_value:"${model.comment}管理",href:"/${model.packageName}/${model.modulePackage}/${model.model}Action/list"/}
*/